Welcome to the solution for step one off for the final project.
And here we are asked to identify the five stocks and get the respective stock takers.
So let's have a look again at the case.
We have our new client Mary Johnson and from nineteen hundred and ninety seven until today she has been
solely invested in two five healthcare stocks that are today the most valuable healthcare stocks in
the U.S. market in terms of market capitalization.
And uh here in Step One We should work with the CSP file listings cleaned out CSP
and first of all we import the library's pandas nonpayment plot lips Seabourn y finance and cufflinks
and then we import our current listings on this deck.
Uh Amex and New York Stock Exchange.
And uh we set uh the symbol column as being the index and that's inspecting our listings that are set
and now we should filter for the five largest healthcare stocks and five largest in terms of market
capitalization and actually health care is a sector that we can find here in the column sector.
So first of all I refer to all healthcare companies.
And uh we can do this year with listings the DOT sector equals healthcare and be safe.
The new data frame and the variable health.
So let's say this year and then we are only interested in the five largest companies in terms of market
capitalization.
And we you see at the end largest method and be safe.
The new data frame with the five largest healthcare companies and the variable large cap healthcare
and have a look.
So here we have for example Johnson and Johnson and Pfizer and here on the left hand side we have the
ticker symbols.